/*
Navicat SQL Server Data Transfer

Source Server         : LOCALHOST
Source Server Version : 110000
Source Host           : .:1433
Source Database       : AAACHAM2
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2014-04-23 00:10:33
*/


-- ----------------------------
-- Table structure for tb2500
-- ----------------------------
DROP TABLE [dbo].[tb2500]
GO
CREATE TABLE [dbo].[tb2500] (
[DivisionID] varchar(20) NOT NULL ,
[TranMonth] int NOT NULL ,
[TranYear] int NULL ,
[ExpenseAccountID] varchar(20) NULL ,
[PayableAccountID] varchar(20) NULL ,
[TimeConvert] money NOT NULL ,
[PayrollMethodID] varchar(20) NULL ,
[DayPerMonth] money NULL ,
[LenAbsentCardNo] int NULL ,
[RateExchange] money NOT NULL DEFAULT ((1)) ,
[OtherDayPerMonth] money NULL ,
[IsOtherDayPerMonth] tinyint NULL ,
[CoefficientDecimals] tinyint NOT NULL DEFAULT ((2)) ,
[AbsentDecimals] tinyint NOT NULL DEFAULT ((2)) ,
[OriginalDecimals] tinyint NOT NULL DEFAULT ((3)) ,
[ConvertedDecimals] tinyint NOT NULL DEFAULT ((3)) ,
[PriceDecimals] tinyint NOT NULL DEFAULT ((3)) ,
[QuantityDecimals] tinyint NOT NULL DEFAULT ((2)) ,
[OthersDecimals] tinyint NOT NULL DEFAULT ((0)) ,
[GAbsentLoanID] varchar(20) NULL ,
[OtherDecimals] int NULL ,
[ProductAbsentMethod] tinyint NOT NULL DEFAULT ((0)) ,
[ConvertedProductAbsent] bit NOT NULL DEFAULT ((0)) 
)


GO


